<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE dita PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<dita>
  <topic id="topic_fstrm">
    <title>auto_explain</title>
    <body>
      <p>The <codeph>auto_explain</codeph> module provides a means for logging execution plans of
        slow statements automatically, without having to run <codeph>EXPLAIN</codeph> by hand.</p>
      <p>The Greenplum Database <codeph>auto_explain</codeph> module was runs only on the Greenplum
        Database master segment host. It is otherwise equivalent in functionality to the PostgreSQL
          <codeph>auto_explain</codeph> module.</p>
    </body>
    <topic id="topic_reg">
      <title>Loading the Module</title>
      <body>
        <p>The <codeph>auto_explain</codeph> module provides no SQL-accessible functions. To use it,
          simply load it into the server. You can load it into an individual session by entering
          this command as a superuser:<codeblock>LOAD 'auto_explain';</codeblock></p>
        <p>More typical usage is to preload it into some or all sessions by including
            <codeph>auto_explain</codeph> in <codeph>session_preload_libraries</codeph> or
            <codeph>shared_preload_libraries</codeph> in <codeph>postgresql.conf</codeph>. Then you
          can track unexpectedly slow queries no matter when they happen. However, this does
          introduce overhead for all queries.</p>
      </body>
    </topic>
    <topic id="topic_info">
      <title>Module Documentation</title>
      <body>
        <p>See <codeph><xref href="https://www.postgresql.org/docs/9.4/auto-explain.html"
              scope="external" format="html">auto_explain</xref></codeph> in the PostgreSQL
          documentation for detailed information about the configuration parameters that control
          this module's behavior.</p>
      </body>
    </topic>
  </topic>
</dita>
